/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80020 (8.0.20)
 Source Host           : localhost:3306
 Source Schema         : teaching

 Target Server Type    : MySQL
 Target Server Version : 80020 (8.0.20)
 File Encoding         : 65001

 Date: 29/03/2024 09:51:07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for carousel
-- ----------------------------
DROP TABLE IF EXISTS `carousel`;
CREATE TABLE `carousel` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '轮播图图片',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '轮播图名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='轮播图管理';

-- ----------------------------
-- Records of carousel
-- ----------------------------
BEGIN;
INSERT INTO `carousel` (`id`, `img`, `name`) VALUES (1, 'http://127.0.0.1:9090/file/a1ce3c755a294ead8ff050a1b62a7fcc.png', '001');
INSERT INTO `carousel` (`id`, `img`, `name`) VALUES (2, 'http://127.0.0.1:9090/file/018db0a7c8de457baefb4331beef87c9.webp', '002');
INSERT INTO `carousel` (`id`, `img`, `name`) VALUES (3, 'http://127.0.0.1:9090/file/bc712a271fd849f0a53d4fb8d0cdac6e.jpg', '003');
COMMIT;

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分类名称',
  `info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分类描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='分类管理';

-- ----------------------------
-- Records of category
-- ----------------------------
BEGIN;
INSERT INTO `category` (`id`, `name`, `info`) VALUES (1, '讲义', '讲义');
INSERT INTO `category` (`id`, `name`, `info`) VALUES (2, '实验', '实验');
INSERT INTO `category` (`id`, `name`, `info`) VALUES (3, '研究', '研究');
INSERT INTO `category` (`id`, `name`, `info`) VALUES (4, '经验', '经验');
INSERT INTO `category` (`id`, `name`, `info`) VALUES (5, '课件', '课件');
COMMIT;

-- ----------------------------
-- Table structure for collect
-- ----------------------------
DROP TABLE IF EXISTS `collect`;
CREATE TABLE `collect` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `user_id` int DEFAULT NULL COMMENT '用户id',
  `item_id` int DEFAULT NULL COMMENT '收藏id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='收藏管理';

-- ----------------------------
-- Records of collect
-- ----------------------------
BEGIN;
INSERT INTO `collect` (`id`, `user_id`, `item_id`) VALUES (9, 1, 2);
INSERT INTO `collect` (`id`, `user_id`, `item_id`) VALUES (10, 1, 3);
INSERT INTO `collect` (`id`, `user_id`, `item_id`) VALUES (3, 1, 13);
INSERT INTO `collect` (`id`, `user_id`, `item_id`) VALUES (4, 2, 1);
INSERT INTO `collect` (`id`, `user_id`, `item_id`) VALUES (7, 2, 4);
INSERT INTO `collect` (`id`, `user_id`, `item_id`) VALUES (8, 2, 16);
COMMIT;

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '内容',
  `user_id` int DEFAULT NULL COMMENT '评论人id',
  `time` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '评论时间',
  `pid` int DEFAULT NULL COMMENT '父id',
  `origin_id` int DEFAULT NULL COMMENT '最上级评论id',
  `item_id` int DEFAULT NULL COMMENT '关联id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='评论功能';

-- ----------------------------
-- Records of comment
-- ----------------------------
BEGIN;
INSERT INTO `comment` (`id`, `content`, `user_id`, `time`, `pid`, `origin_id`, `item_id`) VALUES (6, '1231321', 2, '2024-03-27 10:56:30', NULL, NULL, 0);
INSERT INTO `comment` (`id`, `content`, `user_id`, `time`, `pid`, `origin_id`, `item_id`) VALUES (7, '很好', 1, '2024-03-28 22:55:03', NULL, NULL, 1);
INSERT INTO `comment` (`id`, `content`, `user_id`, `time`, `pid`, `origin_id`, `item_id`) VALUES (8, '课件分享🐮', 1, '2024-03-28 22:55:14', NULL, NULL, 2);
INSERT INTO `comment` (`id`, `content`, `user_id`, `time`, `pid`, `origin_id`, `item_id`) VALUES (9, '谢谢分享', 1, '2024-03-28 22:55:23', NULL, NULL, 6);
INSERT INTO `comment` (`id`, `content`, `user_id`, `time`, `pid`, `origin_id`, `item_id`) VALUES (10, '123123', 1, '2024-03-28 22:55:54', NULL, NULL, 0);
INSERT INTO `comment` (`id`, `content`, `user_id`, `time`, `pid`, `origin_id`, `item_id`) VALUES (11, '123131', 2, '2024-03-29 09:08:09', NULL, NULL, 2);
INSERT INTO `comment` (`id`, `content`, `user_id`, `time`, `pid`, `origin_id`, `item_id`) VALUES (12, '333', 2, '2024-03-29 09:08:21', NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for item
-- ----------------------------
DROP TABLE IF EXISTS `item`;
CREATE TABLE `item` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标题',
  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '封面',
  `user_id` int DEFAULT NULL COMMENT '发布人id',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发布人姓名',
  `create_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发布时间',
  `info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '描述',
  `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件',
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '状态',
  `cate_id` int DEFAULT NULL COMMENT '分类id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='内容管理';

-- ----------------------------
-- Records of item
-- ----------------------------
BEGIN;
INSERT INTO `item` (`id`, `name`, `img`, `user_id`, `user_name`, `create_date`, `info`, `file`, `status`, `cate_id`) VALUES (1, '历史文化导论', 'http://127.0.0.1:9090/file/1e5184095b0149a981b4266ed16290d6.jpeg', 2, '王兰花', '2024-03-28 22:47:35', '\n课程名称：历史文化导论\n\n课程编号：HIST101\n\n讲义：第一讲 - 古代文明的起源\n\n目标：通过本节课的学习，学生将了解古代文明的起源，包括早期人类的进化、农业革命对社会的影响以及早期文明的特征。\n\n引言\n\n介绍古代文明的重要性和影响\n激发学生对古代历史和文化的兴趣\n早期人类的进化\n\n简要介绍人类起源和进化的理论\n讲解早期人类的生活方式和社会组织\n农业革命\n\n解释农业革命对人类社会的转变和影响\n强调农业革命对人口增长、定居生活和社会分工的重要性\n早期文明的特征\n\n探讨早期文明的定义和特征\n以埃及、美索不达米亚和印度河谷文明为例，介绍早期文明的重要成就和特点\n总结与思考题\n\n简要总结本节课的内容和要点\n提出思考题，鼓励学生思考和讨论古代文明的起源和演变\n扩展阅读\n\n推荐相关书籍、文章或网站，供学生进一步探索古代文明的起源和发展', NULL, '可查看', 1);
INSERT INTO `item` (`id`, `name`, `img`, `user_id`, `user_name`, `create_date`, `info`, `file`, `status`, `cate_id`) VALUES (2, '《有趣的汉字》遨游汉字王国PPT教学课件', 'http://127.0.0.1:9090/file/24801f34f46a40bab397bb7d2b2bdbeb.webp', 2, '王兰花', '2024-03-28 22:47:36', '《有趣的汉字》遨游汉字王国PPT教学课件', 'http://127.0.0.1:9090/file/c0be48cb07d64c2685ab2c9bbaa3de93.pptx', '可查看', 5);
INSERT INTO `item` (`id`, `name`, `img`, `user_id`, `user_name`, `create_date`, `info`, `file`, `status`, `cate_id`) VALUES (3, '实验记录！', 'http://127.0.0.1:9090/file/fdb8839896e74ec9b3ca2cc438166990.png', 2, '王兰花', '2024-03-28 22:47:36', '![image.png](http://127.0.0.1:9090/file/7fe490cc95be47e2a101aec0e5aa809d.png)', NULL, '可查看', 2);
INSERT INTO `item` (`id`, `name`, `img`, `user_id`, `user_name`, `create_date`, `info`, `file`, `status`, `cate_id`) VALUES (4, '我的教学经验分享：创造积极学习环境', 'http://127.0.0.1:9090/file/d5443a81a0664b1997db2c0a45bc4959.webp', 3, '张大壮', '2024-03-28 22:47:37', '\n\n大家好！\n\n作为一名教育工作者，我今天想分享一些我在教学过程中积累的经验，特别是关于如何创造积极学习环境的技巧和策略。我希望这些经验对其他教育从业者有所帮助，并且能够促进学生的积极参与和学习成果。\n\n建立良好的师生关系：\n\n建立师生之间的信任和尊重，让学生感受到你对他们的关心和关注。\n鼓励学生积极参与课堂讨论，尊重他们的观点和意见。\n知道每个学生的个人兴趣和需求，尽量满足他们的学习需求。\n创造积极的学习氛围：\n\n营造友好、支持和鼓励的学习环境，让学生感到安全并自由表达自己的观点。\n利用多样化的教学方法和资源，激发学生的学习兴趣和好奇心。\n提供有趣和具有挑战性的学习任务，激发学生的主动学习意愿。\n个性化教学：\n\n尽量满足学生的不同学习风格和能力水平，提供多样化的学习机会和资源。\n鼓励学生根据自己的兴趣和需求制定学习目标，并提供支持和指导。\n提供及时的反馈和评估，帮助学生认识自己的学习进展和改进方向。\n鼓励合作与互动：\n\n促进学生之间的合作和互动，鼓励他们分享知识、交流想法，并共同解决问题。\n利用小组讨论、合作项目和角色扮演等活动，培养学生的团队合作和沟通能力。\n提供机会让学生相互学习和支持，建立学习共同体的意识。\n激发学生的自主学习：\n\n培养学生的自主学习能力和学习动力，鼓励他们主动探索和研究感兴趣的话题。\n提供自主学习的机会和资源，如独立研究项目、学习日记和自主选择的作业。\n培养学生的批判思维和问题解决能力，鼓励他们独立思考和提出质疑。\n以上是我在教学中积累的一些经验，希望对大家有所启发。每个教育工作者都可以根据自己的教学背景和学生群体的需求，适应和调整这些策略。最重要的是，保持对教育的热情和持续的专业发展，与学生一同成长和学习！\n\n期待听到你们的反馈和分享，共同探索更好的教学实践！\n', NULL, '可查看', 4);
INSERT INTO `item` (`id`, `name`, `img`, `user_id`, `user_name`, `create_date`, `info`, `file`, `status`, `cate_id`) VALUES (5, '教学的新厌旧：创新方法促进学习', 'http://127.0.0.1:9090/file/0501e9c8daeb421cbb54580194869785.png', 2, '王兰花', '2024-03-28 22:54:18', '\n大家好！\n\n作为教育工作者，我们时刻面临着挑战，其中之一就是如何保持教学的新鲜感和活力，以激发学生的兴趣和提高学习效果。在这篇文章中，我想探讨一些创新的教学方法，帮助我们摆脱传统的厌旧，为学生带来更具吸引力和有效性的学习体验。\n\n利用技术：\n\n整合技术工具和应用程序，如互动白板、在线教学平台和教育应用程序，以增强教学效果。\n利用多媒体资源，如图像、视频和音频，使课堂内容更生动有趣。\n探索虚拟现实（VR）和增强现实（AR）等新兴技术，创造沉浸式学习体验。\n推崇项目学习：\n\n引入项目学习，让学生通过解决实际问题或完成实践任务来应用所学知识和技能。\n鼓励学生进行跨学科的合作项目，培养团队合作、沟通和解决问题的能力。\n提供机会让学生展示他们的项目成果，增强自信心和动力。\n个性化学习：\n\n制定个性化学习计划，根据学生的兴趣、学习风格和能力差异提供定制化的教学内容和任务。\n使用自适应学习软件和在线测评工具，根据学生的学习进展和需求提供实时反馈和指导。\n鼓励学生制定自己的学习目标，并提供资源和支持帮助他们实现目标。\n激发创造力和批判思维：\n\n鼓励学生进行创造性思考和表达，提供开放性的问题和项目，激发他们的创新和想象力。\n教授批判思维技巧，培养学生对信息的分析和评估能力，以及独立思考和解决问题的能力。\n创造鼓励学生质疑和探索的学习环境，培养批判性思维和主动学习的习惯。\n与现实世界联系：\n\n将课堂内容与实际生活和现实世界联系起来，展示知识的实用性和应用场景。\n邀请行业专家或社区资源人士到课堂上分享经验和应用案例，增强学生对学习内容的认知和兴趣。\n安排实地考察和实践活动，让学生亲身体验所学知识在实际环境中的运用。\n通过采用这些创新的教学方法，我们可以打破传统的教学模式，激发学生的学习热情和主动性。让我们共同努力，探索更多创新的教学策略，为学生带来更有意义和启发性的学习体验！\n\n期待听到大家的想法和分享！', NULL, '可查看', 3);
INSERT INTO `item` (`id`, `name`, `img`, `user_id`, `user_name`, `create_date`, `info`, `file`, `status`, `cate_id`) VALUES (6, '如何做一份教学讲义', 'http://127.0.0.1:9090/file/2debd286f4354aaab44c3ab82127b598.webp', 3, '张大壮', '2024-03-28 22:54:19', '当涉及到教学讲义时，以下是一些建议和指导，帮助你创建一份有效的讲义：\n\n清晰的结构：确保你的讲义有一个清晰的结构，这样学生可以更容易地理解和跟随。使用标题、子标题和编号来组织内容，并确保内容之间有逻辑顺序。\n\n简洁明了的语言：使用简洁明了的语言来表达你的观点和概念。避免使用过于复杂或晦涩的词汇，尽量使用清晰易懂的表达方式。\n\n重点突出：将重要的概念、关键点和关键字突出显示，这有助于学生更好地理解和记忆。使用粗体、斜体、下划线或高亮等方式来强调关键信息。\n\n图表和图像：使用图表、图像和插图来辅助讲解。图表可以清晰地展示数据和关系，图像可以帮助学生形象化地理解抽象概念。确保图表和图像清晰可读，并与讲义的内容相一致。\n\n实例和案例：提供实例和案例来说明概念和理论。实际的例子可以帮助学生更好地理解抽象的概念，并将其应用于实际情境中。\n\n练习和问题：在讲义中添加练习和问题，以帮助学生巩固所学知识。这些练习可以是选择题、填空题、解答题等形式，促使学生主动思考和应用所学内容。\n\n摘要和复习要点：在讲义的末尾提供一个摘要或复习要点的部分。这可以帮助学生回顾和总结所学的内容，并加强他们对重点知识的记忆。\n\n可打印和可编辑性：如果可能的话，提供一个可打印版本的讲义，方便学生在课堂上做笔记或离线学习。另外，考虑提供一个可编辑的电子版本，以便学生可以根据自己的需要进行个性化的学习。\n\n最重要的是，根据你要教授的学科和目标学生群体的需求，个性化地设计和调整讲义，确保它能够有效地传达知识并满足学生的学习需求。', NULL, '可查看', 4);
INSERT INTO `item` (`id`, `name`, `img`, `user_id`, `user_name`, `create_date`, `info`, `file`, `status`, `cate_id`) VALUES (7, '课件分享', 'http://127.0.0.1:9090/file/f579aaffd49e4201be913bb009ba894b.webp', 3, '张大壮', '2024-03-28 22:54:19', '青岛版九年级数学下册《物体的三视图》PPT教学课件(第3课时)，共8页。\n\n复习回顾\n\n根据下面三视图请说出建筑物是什么样子的？共有几层？一共需要多少个小正方体？\n\n精讲点拨\n\n例4 （1）一个几何体的三视图如图所示（单位：mm）。根据三视图描述这个几何体的形状；\n\n（2）画出这个几何体的表面展开图，并计算这个几何体的表面积(精确到1mm2)。\n\n巩固训练\n\n如图是一种工件的三视图，计算该工件的表面积和体积？(分别精确到0.1mm2和 0.1mm3)。\n\n课堂小结\n\n通过本节课的学习，谈谈你的收获？', 'http://127.0.0.1:9090/file/90d63cf379ce4c4591fb7795a4e3d9f4.pptx', '可查看', 5);
COMMIT;

-- ----------------------------
-- Table structure for notice
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '公告标题',
  `info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '公告内容',
  `create_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发布时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='公告管理';

-- ----------------------------
-- Records of notice
-- ----------------------------
BEGIN;
INSERT INTO `notice` (`id`, `name`, `info`, `create_date`) VALUES (1, '系统公告', '我们很高兴宣布推出我们全新的教学资源共享平台！这个平台旨在为教育界的专业人士和学生提供一个交流、分享和获取高质量教学资源的空间。', '2024-03-25');
INSERT INTO `notice` (`id`, `name`, `info`, `create_date`) VALUES (2, '欢迎使用平台', '我们致力于打造一个开放、包容和创新的教育资源共享平台，为教育事业做出贡献。我们欢迎您的加入和贡献！', '2024-03-25');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '内容',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=281 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (1, 'user', 'el-icon-user', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (2, 'house', 'el-icon-house', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (3, 'menu', 'el-icon-menu', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (4, 's-custom', 'el-icon-s-custom', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (5, 's-grid', 'el-icon-s-grid', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (6, 'document', 'el-icon-document', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (7, 'coffee', 'el-icon-coffee\r\n', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (8, 's-marketing', 'el-icon-s-marketing', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (9, 'phone-outline', 'el-icon-phone-outline', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (10, 'platform-eleme', 'el-icon-platform-eleme', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (11, 'eleme', 'el-icon-eleme', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (12, 'delete-solid', 'el-icon-delete-solid', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (13, 'delete', 'el-icon-delete', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (14, 's-tools', 'el-icon-s-tools', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (15, 'setting', 'el-icon-setting', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (16, 'user-solid', 'el-icon-user-solid', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (17, 'phone', 'el-icon-phone', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (18, 'more', 'el-icon-more', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (19, 'more-outline', 'el-icon-more-outline', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (20, 'star-on', 'el-icon-star-on', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (21, 'star-off', 'el-icon-star-off', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (22, 's-goods', 'el-icon-s-goods', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (23, 'goods', 'el-icon-goods', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (24, 'warning', 'el-icon-warning', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (25, 'warning-outline', 'el-icon-warning-outline', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (26, 'question', 'el-icon-question', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (27, 'info', 'el-icon-info', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (28, 'remove', 'el-icon-remove', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (29, 'circle-plus', 'el-icon-circle-plus', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (30, 'success', 'el-icon-success', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (31, 'error', 'el-icon-error', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (32, 'zoom-in', 'el-icon-zoom-in', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (33, 'zoom-out', 'el-icon-zoom-out', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (34, 'remove-outline', 'el-icon-remove-outline', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (35, 'circle-plus-outline', 'el-icon-circle-plus-outline', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (36, 'circle-check', 'el-icon-circle-check', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (37, 'circle-close', 'el-icon-circle-close', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (38, 's-help', 'el-icon-s-help', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (39, 'help', 'el-icon-help', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (40, 'minus', 'el-icon-minus', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (41, 'plus', 'el-icon-plus', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (42, 'check', 'el-icon-check', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (43, 'close', 'el-icon-close', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (44, 'picture', 'el-icon-picture', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (45, 'picture-outline', 'el-icon-picture-outline', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (46, 'picture-outline-round', 'el-icon-picture-outline-round', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (47, 'upload', 'el-icon-upload', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (48, 'upload2', 'el-icon-upload2', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (49, 'download', 'el-icon-download', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (50, 'camera-solid', 'el-icon-camera-solid', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (51, 'camera', 'el-icon-camera', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (52, 'video-camera-solid', 'el-icon-video-camera-solid', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (53, 'video-camera', 'el-icon-video-camera', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (54, 'message-solid', 'el-icon-message-solid', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (55, 'bell', 'el-icon-bell', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (56, 's-cooperation', 'el-icon-s-cooperation', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (57, 's-order', 'el-icon-s-order', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (58, 's-platform', 'el-icon-s-platform', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (59, 's-fold', 'el-icon-s-fold', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (60, 's-unfold', 'el-icon-s-unfold', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (61, 's-operation', 'el-icon-s-operation', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (62, 's-promotion', 'el-icon-s-promotion', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (63, 's-home', 'el-icon-s-home', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (64, 's-release', 'el-icon-s-release', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (65, 's-ticket', 'el-icon-s-ticket', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (66, 's-management', 'el-icon-s-management', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (67, 's-open', 'el-icon-s-open', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (68, 's-shop', 'el-icon-s-shop', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (69, 's-flag', 'el-icon-s-flag', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (70, 's-comment', 'el-icon-s-comment', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (71, 's-finance', 'el-icon-s-finance', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (72, 's-claim', 'el-icon-s-claim', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (73, 's-opportunity', 'el-icon-s-opportunity', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (74, 's-data', 'el-icon-s-data', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (75, 's-check', 'el-icon-s-check', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (76, 'share', 'el-icon-share', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (77, 'd-caret', 'el-icon-d-caret', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (78, 'caret-left', 'el-icon-caret-left', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (79, 'caret-right', 'el-icon-caret-right', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (80, 'caret-bottom', 'el-icon-caret-bottom', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (81, 'caret-top', 'el-icon-caret-top', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (82, 'bottom-left', 'el-icon-bottom-left', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (83, 'bottom-right', 'el-icon-bottom-right', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (84, 'back', 'el-icon-back', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (85, 'right', 'el-icon-right', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (86, 'bottom', 'el-icon-bottom', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (87, 'top', 'el-icon-top', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (88, 'top-left', 'el-icon-top-left', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (89, 'top-right', 'el-icon-top-right', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (90, 'arrow-left', 'el-icon-arrow-left', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (91, 'arrow-right', 'el-icon-arrow-right', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (92, 'arrow-down', 'el-icon-arrow-down', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (93, 'arrow-up', 'el-icon-arrow-up', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (94, 'd-arrow-left', 'el-icon-d-arrow-left', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (95, 'd-arrow-right', 'el-icon-d-arrow-right', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (96, 'video-pause', 'el-icon-video-pause', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (97, 'video-play', 'el-icon-video-play', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (98, 'refresh', 'el-icon-refresh', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (99, 'refresh-right', 'el-icon-refresh-right', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (100, 'refresh-left', 'el-icon-refresh-left', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (101, 'finished', 'el-icon-finished', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (102, 'sort', 'el-icon-sort', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (103, 'sort-up', 'el-icon-sort-up', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (104, 'sort-down', 'el-icon-sort-down', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (105, 'rank', 'el-icon-rank', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (106, 'loading', 'el-icon-loading', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (107, 'view', 'el-icon-view', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (108, 'c-scale-to-original', 'el-icon-c-scale-to-original', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (109, 'date', 'el-icon-date', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (110, 'edit', 'el-icon-edit', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (111, 'edit-outline', 'el-icon-edit-outline', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (112, 'folder', 'el-icon-folder', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (113, 'folder-opened', 'el-icon-folder-opened', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (114, 'folder-add', 'el-icon-folder-add', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (115, 'folder-remove', 'el-icon-folder-remove', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (116, 'folder-delete', 'el-icon-folder-delete', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (117, 'folder-checked', 'el-icon-folder-checked', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (118, 'tickets', 'el-icon-tickets', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (119, 'document-remove', 'el-icon-document-remove', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (120, 'document-delete', 'el-icon-document-delete', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (121, 'document-copy', 'el-icon-document-copy', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (122, 'document-checked', 'el-icon-document-checked', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (123, 'document-add', 'el-icon-document-add', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (124, 'printer', 'el-icon-printer', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (125, 'paperclip', 'el-icon-paperclip', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (126, 'takeaway-box', 'el-icon-takeaway-box', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (127, 'search', 'el-icon-search', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (128, 'monitor', 'el-icon-monitor', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (129, 'attract', 'el-icon-attract', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (130, 'mobile', 'el-icon-mobile', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (131, 'scissors', 'el-icon-scissors', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (132, 'umbrella', 'el-icon-umbrella', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (133, 'headset', 'el-icon-headset', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (134, 'brush', 'el-icon-brush', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (135, 'mouse', 'el-icon-mouse', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (136, 'coordinate', 'el-icon-coordinate', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (137, 'magic-stick', 'el-icon-magic-stick', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (138, 'reading', 'el-icon-reading', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (139, 'data-line', 'el-icon-data-line', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (140, 'data-board', 'el-icon-data-board', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (141, 'pie-chart', 'el-icon-pie-chart', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (142, 'data-analysis', 'el-icon-data-analysis', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (143, 'collection-tag', 'el-icon-collection-tag', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (144, 'film', 'el-icon-film', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (145, 'suitcase', 'el-icon-suitcase', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (146, 'suitcase-1', 'el-icon-suitcase-1', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (147, 'receiving', 'el-icon-receiving', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (148, 'collection', 'el-icon-collection', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (149, 'files', 'el-icon-files', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (150, 'notebook-1', 'el-icon-notebook-1', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (151, 'notebook-2', 'el-icon-notebook-2', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (152, 'toilet-paper', 'el-icon-toilet-paper', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (153, 'office-building', 'el-icon-office-building', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (154, 'school', 'el-icon-school', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (155, 'table-lamp', 'el-icon-table-lamp', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (156, 'no-smoking', 'el-icon-no-smoking', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (157, 'smoking', 'el-icon-smoking', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (158, 'shopping-cart-full', 'el-icon-shopping-cart-full', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (159, 'shopping-cart-1', 'el-icon-shopping-cart-1', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (160, 'shopping-cart-2', 'el-icon-shopping-cart-2', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (161, 'shopping-bag-1', 'el-icon-shopping-bag-1', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (162, 'shopping-bag-2', 'el-icon-shopping-bag-2', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (163, 'sold-out', 'el-icon-sold-out', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (164, 'sell', 'el-icon-sell', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (165, 'present', 'el-icon-present', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (166, 'box', 'el-icon-box', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (167, 'bank-card', 'el-icon-bank-card', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (168, 'money', 'el-icon-money', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (169, 'coin', 'el-icon-coin', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (170, 'wallet', 'el-icon-wallet', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (171, 'discount', 'el-icon-discount', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (172, 'price-tag', 'el-icon-price-tag', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (173, 'news', 'el-icon-news', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (174, 'guide', 'el-icon-guide', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (175, 'male', 'el-icon-male', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (176, 'female', 'el-icon-female', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (177, 'thumb', 'el-icon-thumb', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (178, 'cpu', 'el-icon-cpu', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (179, 'link', 'el-icon-link', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (180, 'connection', 'el-icon-connection', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (181, 'open', 'el-icon-open', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (182, 'turn-off', 'el-icon-turn-off', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (183, 'set-up', 'el-icon-set-up', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (184, 'chat-round', 'el-icon-chat-round', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (185, 'chat-line-round', 'el-icon-chat-line-round', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (186, 'chat-square', 'el-icon-chat-square', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (187, 'chat-dot-round', 'el-icon-chat-dot-round', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (188, 'chat-dot-square', 'el-icon-chat-dot-square', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (189, 'chat-line-square', 'el-icon-chat-line-square', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (190, 'message', 'el-icon-message', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (191, 'postcard', 'el-icon-postcard', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (192, 'position', 'el-icon-position', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (193, 'turn-off-microphone', 'el-icon-turn-off-microphone', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (194, 'microphone', 'el-icon-microphone', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (195, 'close-notification', 'el-icon-close-notification', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (196, 'bangzhu', 'el-icon-bangzhu', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (197, 'time', 'el-icon-time', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (198, 'odometer', 'el-icon-odometer', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (199, 'crop', 'el-icon-crop', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (200, 'aim', 'el-icon-aim', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (201, 'switch-button', 'el-icon-switch-button', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (202, 'full-screen', 'el-icon-full-screen', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (203, 'copy-document', 'el-icon-copy-document', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (204, 'mic', 'el-icon-mic', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (205, 'stopwatch', 'el-icon-stopwatch', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (206, 'medal-1', 'el-icon-medal-1', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (207, 'medal', 'el-icon-medal', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (208, 'trophy', 'el-icon-trophy', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (209, 'trophy-1', 'el-icon-trophy-1', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (210, 'first-aid-kit', 'el-icon-first-aid-kit', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (211, 'discover', 'el-icon-discover', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (212, 'place', 'el-icon-place', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (213, 'location', 'el-icon-location', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (214, 'location-outline', 'el-icon-location-outline', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (215, 'location-information', 'el-icon-location-information', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (216, 'add-location', 'el-icon-add-location', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (217, 'delete-location', 'el-icon-delete-location', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (218, 'map-location', 'el-icon-map-location', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (219, 'alarm-clock', 'el-icon-alarm-clock', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (220, 'timer', 'el-icon-timer', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (221, 'watch-1', 'el-icon-watch-1', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (222, 'watch', 'el-icon-watch', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (223, 'lock', 'el-icon-lock', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (224, 'unlock', 'el-icon-unlock', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (225, 'key', 'el-icon-key', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (226, 'service', 'el-icon-service', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (227, 'mobile-phone', 'el-icon-mobile-phone', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (228, 'bicycle', 'el-icon-bicycle', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (229, 'truck', 'el-icon-truck', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (230, 'ship', 'el-icon-ship', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (231, 'basketball', 'el-icon-basketball', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (232, 'football', 'el-icon-football', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (233, 'soccer', 'el-icon-soccer', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (234, 'baseball', 'el-icon-baseball', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (235, 'wind-power', 'el-icon-wind-power', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (236, 'light-rain', 'el-icon-light-rain', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (237, 'lightning', 'el-icon-lightning', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (238, 'heavy-rain', 'el-icon-heavy-rain', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (239, 'sunrise', 'el-icon-sunrise', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (240, 'sunrise-1', 'el-icon-sunrise-1', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (241, 'sunset', 'el-icon-sunset', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (242, 'sunny', 'el-icon-sunny', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (243, 'cloudy', 'el-icon-cloudy', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (244, 'partly-cloudy', 'el-icon-partly-cloudy', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (245, 'cloudy-and-sunny', 'el-icon-cloudy-and-sunny', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (246, 'moon', 'el-icon-moon', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (247, 'moon-night', 'el-icon-moon-night', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (248, 'dish', 'el-icon-dish', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (249, 'dish-1', 'el-icon-dish-1', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (250, 'food', 'el-icon-food', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (251, 'chicken', 'el-icon-chicken', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (252, 'fork-spoon', 'el-icon-fork-spoon', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (253, 'knife-fork', 'el-icon-knife-fork', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (254, 'burger', 'el-icon-burger', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (255, 'tableware', 'el-icon-tableware', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (256, 'sugar', 'el-icon-sugar', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (257, 'dessert', 'el-icon-dessert', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (258, 'ice-cream', 'el-icon-ice-cream', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (259, 'hot-water', 'el-icon-hot-water', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (260, 'water-cup', 'el-icon-water-cup', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (261, 'coffee-cup', 'el-icon-coffee-cup', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (262, 'cold-drink', 'el-icon-cold-drink', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (263, 'goblet', 'el-icon-goblet', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (264, 'goblet-full', 'el-icon-goblet-full', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (265, 'goblet-square', 'el-icon-goblet-square', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (266, 'goblet-square-full', 'el-icon-goblet-square-full', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (267, 'refrigerator', 'el-icon-refrigerator', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (268, 'grape', 'el-icon-grape', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (269, 'watermelon', 'el-icon-watermelon', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (270, 'cherry', 'el-icon-cherry', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (271, 'apple', 'el-icon-apple', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (272, 'pear', 'el-icon-pear', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (273, 'orange', 'el-icon-orange', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (274, 'ice-tea', 'el-icon-ice-tea', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (275, 'ice-drink', 'el-icon-ice-drink', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (276, 'milk-tea', 'el-icon-milk-tea', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (277, 'potato-strips', 'el-icon-potato-strips', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (278, 'lollipop', 'el-icon-lollipop', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (279, 'ice-cream-square', 'el-icon-ice-cream-square', 'icon');
INSERT INTO `sys_dict` (`id`, `name`, `value`, `type`) VALUES (280, 'ice-cream-round', 'el-icon-ice-cream-round', 'icon');
COMMIT;

-- ----------------------------
-- Table structure for sys_file
-- ----------------------------
DROP TABLE IF EXISTS `sys_file`;
CREATE TABLE `sys_file` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件名称',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件类型',
  `size` bigint DEFAULT NULL COMMENT '文件大小(kb)',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '下载链接',
  `md5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件md5',
  `is_delete` tinyint(1) DEFAULT '0' COMMENT '是否删除',
  `enable` tinyint(1) DEFAULT '1' COMMENT '是否禁用链接',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_file
-- ----------------------------
BEGIN;
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (1, '管理员头像.jpeg', 'jpeg', 43, 'http://localhost:9090/file/e53f871aea73484ba8427ee425c99228.jpeg', '04752e16e2733a588945b43388a2f675', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (2, '王兰花头像.jpeg', 'jpeg', 25, 'http://localhost:9090/file/134436b9a8964b3b9a0f9f71c83c0c05.jpeg', '002c6336bf36c89046e8a6064bc103a0', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (3, '张大壮头像.jpeg', 'jpeg', 49, 'http://localhost:9090/file/a70137388e0345dd9db8463fd897a1ae.jpeg', '4e6ce72ae4c2412ac1d73db50b6ac537', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (4, '1.webp', 'webp', 104, 'http://127.0.0.1:9090/file/ba909de2bf81416fadb91dad4219ff5d.webp', '10888f41fe3ef2d741d1b1b553fb19a1', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (5, '2.jpg', 'jpg', 186, 'http://127.0.0.1:9090/file/4b3b684e314c46879f9f057ef27c8fd0.jpg', '4b721528c30213bb68e27df649190fb3', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (6, '1.webp', 'webp', 104, 'http://127.0.0.1:9090/file/ba909de2bf81416fadb91dad4219ff5d.webp', '10888f41fe3ef2d741d1b1b553fb19a1', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (7, '3.png', 'png', 139, 'http://127.0.0.1:9090/file/fdb8839896e74ec9b3ca2cc438166990.png', 'f211195791c62ba75edeff24af6fb219', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (8, '1.jpeg', 'jpeg', 209, 'http://127.0.0.1:9090/file/1e5184095b0149a981b4266ed16290d6.jpeg', 'd438a3c523da6953eba8ea8c868ef8d2', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (9, '课件.webp', 'webp', 12, 'http://127.0.0.1:9090/file/24801f34f46a40bab397bb7d2b2bdbeb.webp', '564be50095367f6dcc2d7a8e0c6f6768', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (10, '汉字主题3.pptx', 'pptx', 7025, 'http://127.0.0.1:9090/file/c0be48cb07d64c2685ab2c9bbaa3de93.pptx', '81a737c4cffc36d4422e96f124a05fb6', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (11, '汉字主题3.pptx', 'pptx', 7025, 'http://127.0.0.1:9090/file/c0be48cb07d64c2685ab2c9bbaa3de93.pptx', '81a737c4cffc36d4422e96f124a05fb6', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (12, '3.png', 'png', 139, 'http://127.0.0.1:9090/file/fdb8839896e74ec9b3ca2cc438166990.png', 'f211195791c62ba75edeff24af6fb219', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (13, 'image.png', 'png', 329, 'http://127.0.0.1:9090/file/7fe490cc95be47e2a101aec0e5aa809d.png', '3f4228a595912f8fb665557e4042bc9e', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (14, '2.jpg', 'jpg', 186, 'http://127.0.0.1:9090/file/4b3b684e314c46879f9f057ef27c8fd0.jpg', '4b721528c30213bb68e27df649190fb3', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (15, '2.webp', 'webp', 39, 'http://127.0.0.1:9090/file/d5443a81a0664b1997db2c0a45bc4959.webp', 'c8e08372c351de67260033041f03b904', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (16, '23.png', 'png', 294, 'http://127.0.0.1:9090/file/0501e9c8daeb421cbb54580194869785.png', 'd2e61b49c6d4a46b8d5871e59e56e89a', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (17, '12.webp', 'webp', 28, 'http://127.0.0.1:9090/file/2debd286f4354aaab44c3ab82127b598.webp', '531cdb3756bb246d63e6c76eb9714b73', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (18, '34.webp', 'webp', 58, 'http://127.0.0.1:9090/file/f579aaffd49e4201be913bb009ba894b.webp', '83fd4e1f1b0841690e0ddda169158035', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (19, '物体的三视图-第三课时_课件1.pptx', 'pptx', 205, 'http://127.0.0.1:9090/file/90d63cf379ce4c4591fb7795a4e3d9f4.pptx', '71e832ccf36c8cf4c1ea980ffa4eb9d8', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (20, 'banner1.png', 'png', 110, 'http://127.0.0.1:9090/file/a1ce3c755a294ead8ff050a1b62a7fcc.png', 'ba4d456863f2a3c00819c371fe1dc069', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (21, 'banner2.png', 'png', 986, 'http://127.0.0.1:9090/file/31eb33e463e549e59e435bdec154efde.png', '7b139ce69b3c86ae121160845b5aa3f1', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (22, 'banner3.jpg', 'jpg', 162, 'http://127.0.0.1:9090/file/bc712a271fd849f0a53d4fb8d0cdac6e.jpg', '7872ed342d1d6c22d2d07068eb477c16', 0, 1);
INSERT INTO `sys_file` (`id`, `name`, `type`, `size`, `url`, `md5`, `is_delete`, `enable`) VALUES (23, '111.webp', 'webp', 22, 'http://127.0.0.1:9090/file/018db0a7c8de457baefb4331beef87c9.webp', 'c6149d0f74c6dae3d316eabb234264d2', 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '路径',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图标',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
  `pid` int DEFAULT NULL COMMENT '父级id',
  `page_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '页面路径',
  `sort_num` int DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`id`, `name`, `path`, `icon`, `description`, `pid`, `page_path`, `sort_num`) VALUES (4, '系统管理', NULL, 'el-icon-s-grid', NULL, NULL, NULL, 9999);
INSERT INTO `sys_menu` (`id`, `name`, `path`, `icon`, `description`, `pid`, `page_path`, `sort_num`) VALUES (5, '用户管理', '/user', 'el-icon-user', NULL, 4, 'User', 301);
INSERT INTO `sys_menu` (`id`, `name`, `path`, `icon`, `description`, `pid`, `page_path`, `sort_num`) VALUES (6, '角色管理', '/role', 'el-icon-s-custom', NULL, 4, 'Role', 302);
INSERT INTO `sys_menu` (`id`, `name`, `path`, `icon`, `description`, `pid`, `page_path`, `sort_num`) VALUES (7, '菜单管理', '/menu', 'el-icon-menu', NULL, 4, 'Menu', 303);
INSERT INTO `sys_menu` (`id`, `name`, `path`, `icon`, `description`, `pid`, `page_path`, `sort_num`) VALUES (8, '文件管理', '/file', 'el-icon-document', NULL, 4, 'File', 304);
INSERT INTO `sys_menu` (`id`, `name`, `path`, `icon`, `description`, `pid`, `page_path`, `sort_num`) VALUES (10, '主页', '/home', 'el-icon-house', NULL, NULL, 'Home', 0);
INSERT INTO `sys_menu` (`id`, `name`, `path`, `icon`, `description`, `pid`, `page_path`, `sort_num`) VALUES (11, '分类管理', '/category', 'el-icon-menu', NULL, NULL, 'Category', 999);
INSERT INTO `sys_menu` (`id`, `name`, `path`, `icon`, `description`, `pid`, `page_path`, `sort_num`) VALUES (13, '轮播图管理', '/carousel', 'el-icon-menu', NULL, NULL, 'Carousel', 999);
INSERT INTO `sys_menu` (`id`, `name`, `path`, `icon`, `description`, `pid`, `page_path`, `sort_num`) VALUES (14, '公告管理', '/notice', 'el-icon-menu', NULL, NULL, 'Notice', 999);
INSERT INTO `sys_menu` (`id`, `name`, `path`, `icon`, `description`, `pid`, `page_path`, `sort_num`) VALUES (15, '内容管理', '/item', 'el-icon-menu', NULL, NULL, 'Item', 999);
INSERT INTO `sys_menu` (`id`, `name`, `path`, `icon`, `description`, `pid`, `page_path`, `sort_num`) VALUES (16, '评论管理', '/comment', 'el-icon-menu', NULL, NULL, 'Comment', 999);
INSERT INTO `sys_menu` (`id`, `name`, `path`, `icon`, `description`, `pid`, `page_path`, `sort_num`) VALUES (17, '收藏管理', '/collect', 'el-icon-menu', NULL, NULL, 'Collect', 999);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
  `flag` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '唯一标识',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`id`, `name`, `description`, `flag`) VALUES (1, '管理员', '管理员', 'ROLE_ADMIN');
INSERT INTO `sys_role` (`id`, `name`, `description`, `flag`) VALUES (2, '普通用户', '普通用户', 'ROLE_USER');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `role_id` int NOT NULL COMMENT '角色id',
  `menu_id` int NOT NULL COMMENT '菜单id',
  PRIMARY KEY (`role_id`,`menu_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 4);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 6);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 7);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 8);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 10);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 11);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 13);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 14);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 15);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 16);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户名',
  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '密码',
  `nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '昵称',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '电话',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '地址',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `avatar_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '头像',
  `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '角色',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `email`, `phone`, `address`, `create_time`, `avatar_url`, `role`) VALUES (1, 'admin', 'admin', '管理员', 'admin@qq.com', '18888888888', '湖北武汉', '2024-01-01 00:00:00', 'http://localhost:9090/file/e53f871aea73484ba8427ee425c99228.jpeg', 'ROLE_ADMIN');
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `email`, `phone`, `address`, `create_time`, `avatar_url`, `role`) VALUES (2, '111', '111', '王兰花', 'wang@qq.com', '18888888888', '湖北武汉', '2024-01-01 00:00:00', 'http://localhost:9090/file/134436b9a8964b3b9a0f9f71c83c0c05.jpeg', 'ROLE_USER');
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `email`, `phone`, `address`, `create_time`, `avatar_url`, `role`) VALUES (3, '222', '222', '张大壮', 'zhang@qq.com', '18888888888', '湖北武汉', '2024-01-01 00:00:00', 'http://localhost:9090/file/a70137388e0345dd9db8463fd897a1ae.jpeg', 'ROLE_USER');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
